from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class CourtRegister(Base):
    __tablename__ = "TYC_JR_COURT_REGISTER"
    LITIGANT = Column(String(255))
    FILINGDATE = Column(String(255))
    LITIGANTGIDS = Column(String(255))
    CASESTATUS = Column(String(255))
    SOURCE = Column(String(255))
    CONTENT = Column(Text)
    CASETYPE = Column(String(255))
    SOURCEURL = Column(String(255))
    DEFENDANT = Column(String(255))
    JUGE = Column(String(255))
    STARTTIME = Column(String(255))
    ID = Column(String(255),primary_key=True)
    DEPARTMENT = Column(String(255))
    AREA = Column(String(255))
    PLAINTIFF = Column(String(255))
    ASSISTANT = Column(String(255))
    COURT = Column(String(255))
    CASENO = Column(String(255))
    CASEREASON = Column(String(255))
    CLOSEDATE = Column(String(255))
    THIRD = Column(String(255))
    CREATETIME = Column(String(255))
    CID = Column(Integer)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)